package com.dynabook.ems.model.vo;

import cn.idev.excel.annotation.ExcelIgnore;
import cn.idev.excel.annotation.ExcelProperty;
import cn.idev.excel.annotation.write.style.ColumnWidth;
import cn.idev.excel.annotation.write.style.HeadRowHeight;
import lombok.Data;

import java.io.Serializable;

/**
 * 平均单耗（BOM）导出VO
 */
@Data
@HeadRowHeight(30) // 设置表头行高为30
@ColumnWidth(20)   // 设置默认列宽为20
public class AverageConsumptionExportVO implements Serializable {
    
    private static final long serialVersionUID = 1L;
    
    /**
     * 工单号（不导出，仅用于查询Redis）
     */
    @ExcelIgnore
    private String workOrderNum;

    /**
     * 单耗区间
     */
    @ExcelProperty(value = {"单耗区间"}, index = 0)
    @ColumnWidth(25)
    private String consumptionPeriod;

    /**
     * 成品料号
     */
    @ExcelProperty(value = {"成品料号"}, index = 1)
    @ColumnWidth(20)
    private String finishedProductModel;

    /**
     * 成品名称
     */
    @ExcelProperty(value = {"成品名称"}, index = 2)
    @ColumnWidth(30)
    private String finishedProductName;

    /**
     * 序号
     */
    @ExcelProperty(value = {"序号"}, index = 3)
    @ColumnWidth(8)
    private Integer sequenceNumber;

    /**
     * 料件料号
     */
    @ExcelProperty(value = {"料件料号"}, index = 4)
    @ColumnWidth(20)
    private String partNumber;

    /**
     * 样品名称
     */
    @ExcelProperty(value = {"样品名称"}, index = 5)
    @ColumnWidth(25)
    private String sampleName;

    /**
     * 料件单位
     */
    @ExcelProperty(value = {"料件单位"}, index = 6)
    @ColumnWidth(12)
    private String partUnit;

    /**
     * 平均单耗
     */
    @ExcelProperty(value = {"平均单耗"}, index = 7)
    @ColumnWidth(15)
    private String averageConsumption;
}

